package com.xtsoft.platform.base.system.repository;


import com.xtsoft.core.repository.GenericRepository;
import com.xtsoft.platform.base.system.domain.SysDictionary;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface SysDictionaryRepository extends GenericRepository<SysDictionary, String> {
	@Query(value = "SELECT * FROM sys_dictionary where parentNodeId in (select nodeId from sys_dictionary where paraName='任务点评')",nativeQuery = true)
	public List<SysDictionary> getAllSysDictionarieByParaName();
}
